{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "\n",
    "import os\n",
    "\n",
    "sns.set(rc={'figure.figsize':(16,8)})\n",
    "\n",
    "#Change this to your data directory\n",
    "data_dir = '../data/train_data/trace/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "datasets = {}\n",
    "for x in os.listdir(data_dir):\n",
    "    datasets[x] = pd.read_csv(data_dir + x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(18991914, 9)\n",
      "(3650205, 9)\n",
      "(14600820, 10)\n",
      "(3650205, 9)\n",
      "(730041, 9)\n",
      "(730041, 9)\n"
     ]
    }
   ],
   "source": [
    "for i in datasets:\n",
    "    datasets[i] = datasets[i].sort_values(by=['traceId','startTime'])\n",
    "    print(datasets[i].shape)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['trace_jdbc.csv', 'trace_csf.csv', 'trace_local.csv', 'trace_remote_process.csv', 'trace_osb.csv', 'trace_fly_remote.csv'])"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "datasets.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(18991914, 9)"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = datasets['trace_jdbc.csv']\n",
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1588607385406"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.max(df['startTime']) - 1000 * 60 * 10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df[df['startTime'] >= 1588521600062  - (1000 * 60 * 10)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(18991914, 9)"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_single_trace = pd.DataFrame(columns=datasets[list(datasets.keys())[0]].columns)\n",
    "for i in datasets:\n",
    "    df_single_trace = df_single_trace.append(datasets[i][datasets[i].traceId == '00004171de2e758c4842'], ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>callType</th>\n",
       "      <th>startTime</th>\n",
       "      <th>elapsedTime</th>\n",
       "      <th>success</th>\n",
       "      <th>traceId</th>\n",
       "      <th>id</th>\n",
       "      <th>pid</th>\n",
       "      <th>cmdb_id</th>\n",
       "      <th>dsName</th>\n",
       "      <th>serviceName</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>OSB</td>\n",
       "      <td>1588570518924</td>\n",
       "      <td>380.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>3b2a9171de2e758c4843</td>\n",
       "      <td>None</td>\n",
       "      <td>os_021</td>\n",
       "      <td>NaN</td>\n",
       "      <td>osb_001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>CSF</td>\n",
       "      <td>1588570518929</td>\n",
       "      <td>338.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>2d6ca171de2e75914849</td>\n",
       "      <td>3b2a9171de2e758c4843</td>\n",
       "      <td>os_021</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csf_001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>RemoteProcess</td>\n",
       "      <td>1588570518930</td>\n",
       "      <td>336.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>2d6ca171de2e75914849</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csf_001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>FlyRemote</td>\n",
       "      <td>1588570518932</td>\n",
       "      <td>5.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>a41a9171de2e75941824</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>fly_remote_001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>CSF</td>\n",
       "      <td>1588570518938</td>\n",
       "      <td>44.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>2b0d6171de2e759a1828</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csf_002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>RemoteProcess</td>\n",
       "      <td>1588570518942</td>\n",
       "      <td>39.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>ffa48171de2e759e2825</td>\n",
       "      <td>2b0d6171de2e759a1828</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csf_002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570518965</td>\n",
       "      <td>9.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>cbcfc171de2e75b52860</td>\n",
       "      <td>ffa48171de2e759e2825</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>local_method_011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570518965</td>\n",
       "      <td>3.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>a52e4171de2e75b52863</td>\n",
       "      <td>cbcfc171de2e75b52860</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570518972</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>fa2fe171de2e75bc2880</td>\n",
       "      <td>cbcfc171de2e75b52860</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>CSF</td>\n",
       "      <td>1588570518984</td>\n",
       "      <td>54.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>1e068171de2e75c71834</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csf_003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>RemoteProcess</td>\n",
       "      <td>1588570518990</td>\n",
       "      <td>44.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>73c90171de2e75ce2907</td>\n",
       "      <td>1e068171de2e75c71834</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csf_003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519004</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>89bdd171de2e75dc2926</td>\n",
       "      <td>cbc31171de2e75dc2923</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519004</td>\n",
       "      <td>11.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>cbc31171de2e75dc2923</td>\n",
       "      <td>73c90171de2e75ce2907</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>local_method_013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519012</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>c77f4171de2e75e42943</td>\n",
       "      <td>cbc31171de2e75dc2923</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519022</td>\n",
       "      <td>7.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>cb38e171de2e75ee2953</td>\n",
       "      <td>73c90171de2e75ce2907</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>local_method_014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519026</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>6d325171de2e75f22970</td>\n",
       "      <td>cb38e171de2e75ee2953</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>CSF</td>\n",
       "      <td>1588570519041</td>\n",
       "      <td>61.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>ec8b7171de2e76011840</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csf_004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>RemoteProcess</td>\n",
       "      <td>1588570519045</td>\n",
       "      <td>56.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>4d259171de2e76053004</td>\n",
       "      <td>ec8b7171de2e76011840</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csf_004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519058</td>\n",
       "      <td>13.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>b2de2171de2e76123027</td>\n",
       "      <td>4d259171de2e76053004</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>local_method_015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519058</td>\n",
       "      <td>3.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>57b70171de2e76123030</td>\n",
       "      <td>b2de2171de2e76123027</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519068</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>bbcbf171de2e761c3053</td>\n",
       "      <td>b2de2171de2e76123027</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519073</td>\n",
       "      <td>5.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>cf1eb171de2e76213063</td>\n",
       "      <td>4d259171de2e76053004</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>local_method_016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519075</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>6375d171de2e76233069</td>\n",
       "      <td>cf1eb171de2e76213063</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>CSF</td>\n",
       "      <td>1588570519104</td>\n",
       "      <td>26.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>3c536171de2e763f1846</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csf_005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>RemoteProcess</td>\n",
       "      <td>1588570519106</td>\n",
       "      <td>23.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>336e7171de2e76423087</td>\n",
       "      <td>3c536171de2e763f1846</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>NaN</td>\n",
       "      <td>csf_005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519113</td>\n",
       "      <td>7.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>8fd44171de2e76493099</td>\n",
       "      <td>336e7171de2e76423087</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>local_method_017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519113</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>ae9e2171de2e76493102</td>\n",
       "      <td>8fd44171de2e76493099</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519118</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>36fd3171de2e764e3111</td>\n",
       "      <td>8fd44171de2e76493099</td>\n",
       "      <td>docker_006</td>\n",
       "      <td>db_003</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519131</td>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>4cd5f171de2e765b1868</td>\n",
       "      <td>a0d50171de2e765b1863</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519131</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>a0d50171de2e765b1863</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519132</td>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>e7045171de2e765c1874</td>\n",
       "      <td>a0d50171de2e765b1863</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519133</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>65389171de2e765d1876</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519134</td>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>48a3e171de2e765e1884</td>\n",
       "      <td>65389171de2e765d1876</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519135</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>0d7f4171de2e765f1888</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519136</td>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>e6299171de2e76601891</td>\n",
       "      <td>0d7f4171de2e765f1888</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519137</td>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>279be171de2e76611899</td>\n",
       "      <td>52591171de2e76611896</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519137</td>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>52591171de2e76611896</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519138</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>bdf07171de2e76621903</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519139</td>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>6a194171de2e76631909</td>\n",
       "      <td>bdf07171de2e76621903</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519140</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>3743e171de2e76641913</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519141</td>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>0abff171de2e76651919</td>\n",
       "      <td>3743e171de2e76641913</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519142</td>\n",
       "      <td>4.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>08150171de2e76661923</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519145</td>\n",
       "      <td>0.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>466a8171de2e76691934</td>\n",
       "      <td>08150171de2e76661923</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519146</td>\n",
       "      <td>12.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>34d9b171de2e766a1941</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519148</td>\n",
       "      <td>9.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>d38af171de2e766c1956</td>\n",
       "      <td>34d9b171de2e766a1941</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519159</td>\n",
       "      <td>3.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>1d347171de2e76771966</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519160</td>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>0bdb7171de2e76781973</td>\n",
       "      <td>1d347171de2e76771966</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519162</td>\n",
       "      <td>4.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>4dec7171de2e767a1980</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519165</td>\n",
       "      <td>0.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>c1567171de2e767d1989</td>\n",
       "      <td>4dec7171de2e767a1980</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519166</td>\n",
       "      <td>3.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>35818171de2e767e1998</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519168</td>\n",
       "      <td>0.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>517b0171de2e76802008</td>\n",
       "      <td>35818171de2e767e1998</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519170</td>\n",
       "      <td>3.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>50cbd171de2e76812013</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519172</td>\n",
       "      <td>0.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>bc5dd171de2e76842024</td>\n",
       "      <td>50cbd171de2e76812013</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519173</td>\n",
       "      <td>5.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>1298b171de2e76852028</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>local_method_009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519177</td>\n",
       "      <td>1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>1e128171de2e76892041</td>\n",
       "      <td>1298b171de2e76852028</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_009</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>LOCAL</td>\n",
       "      <td>1588570519179</td>\n",
       "      <td>82.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>571d7171de2e768b2048</td>\n",
       "      <td>6f699171de2e75921822</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_007</td>\n",
       "      <td>local_method_010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519179</td>\n",
       "      <td>2.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>33267171de2e768b2051</td>\n",
       "      <td>571d7171de2e768b2048</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_007</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>JDBC</td>\n",
       "      <td>1588570519257</td>\n",
       "      <td>3.0</td>\n",
       "      <td>True</td>\n",
       "      <td>00004171de2e758c4842</td>\n",
       "      <td>a2c9a171de2e76d92064</td>\n",
       "      <td>571d7171de2e768b2048</td>\n",
       "      <td>docker_004</td>\n",
       "      <td>db_007</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         callType      startTime  elapsedTime success               traceId  \\\n",
       "56            OSB  1588570518924        380.0    True  00004171de2e758c4842   \n",
       "26            CSF  1588570518929        338.0    True  00004171de2e758c4842   \n",
       "51  RemoteProcess  1588570518930        336.0    True  00004171de2e758c4842   \n",
       "57      FlyRemote  1588570518932          5.0    True  00004171de2e758c4842   \n",
       "27            CSF  1588570518938         44.0    True  00004171de2e758c4842   \n",
       "52  RemoteProcess  1588570518942         39.0    True  00004171de2e758c4842   \n",
       "31          LOCAL  1588570518965          9.0    True  00004171de2e758c4842   \n",
       "0            JDBC  1588570518965          3.0    True  00004171de2e758c4842   \n",
       "1            JDBC  1588570518972          2.0    True  00004171de2e758c4842   \n",
       "28            CSF  1588570518984         54.0    True  00004171de2e758c4842   \n",
       "53  RemoteProcess  1588570518990         44.0    True  00004171de2e758c4842   \n",
       "2            JDBC  1588570519004          2.0    True  00004171de2e758c4842   \n",
       "32          LOCAL  1588570519004         11.0    True  00004171de2e758c4842   \n",
       "3            JDBC  1588570519012          2.0    True  00004171de2e758c4842   \n",
       "33          LOCAL  1588570519022          7.0    True  00004171de2e758c4842   \n",
       "4            JDBC  1588570519026          2.0    True  00004171de2e758c4842   \n",
       "29            CSF  1588570519041         61.0    True  00004171de2e758c4842   \n",
       "54  RemoteProcess  1588570519045         56.0    True  00004171de2e758c4842   \n",
       "34          LOCAL  1588570519058         13.0    True  00004171de2e758c4842   \n",
       "5            JDBC  1588570519058          3.0    True  00004171de2e758c4842   \n",
       "6            JDBC  1588570519068          2.0    True  00004171de2e758c4842   \n",
       "35          LOCAL  1588570519073          5.0    True  00004171de2e758c4842   \n",
       "7            JDBC  1588570519075          2.0    True  00004171de2e758c4842   \n",
       "30            CSF  1588570519104         26.0    True  00004171de2e758c4842   \n",
       "55  RemoteProcess  1588570519106         23.0    True  00004171de2e758c4842   \n",
       "36          LOCAL  1588570519113          7.0    True  00004171de2e758c4842   \n",
       "8            JDBC  1588570519113          2.0    True  00004171de2e758c4842   \n",
       "9            JDBC  1588570519118          2.0    True  00004171de2e758c4842   \n",
       "10           JDBC  1588570519131          1.0    True  00004171de2e758c4842   \n",
       "37          LOCAL  1588570519131          2.0    True  00004171de2e758c4842   \n",
       "11           JDBC  1588570519132          1.0    True  00004171de2e758c4842   \n",
       "38          LOCAL  1588570519133          2.0    True  00004171de2e758c4842   \n",
       "12           JDBC  1588570519134          1.0    True  00004171de2e758c4842   \n",
       "39          LOCAL  1588570519135          2.0    True  00004171de2e758c4842   \n",
       "13           JDBC  1588570519136          1.0    True  00004171de2e758c4842   \n",
       "14           JDBC  1588570519137          1.0    True  00004171de2e758c4842   \n",
       "40          LOCAL  1588570519137          1.0    True  00004171de2e758c4842   \n",
       "41          LOCAL  1588570519138          2.0    True  00004171de2e758c4842   \n",
       "15           JDBC  1588570519139          1.0    True  00004171de2e758c4842   \n",
       "42          LOCAL  1588570519140          2.0    True  00004171de2e758c4842   \n",
       "16           JDBC  1588570519141          1.0    True  00004171de2e758c4842   \n",
       "43          LOCAL  1588570519142          4.0    True  00004171de2e758c4842   \n",
       "17           JDBC  1588570519145          0.0    True  00004171de2e758c4842   \n",
       "44          LOCAL  1588570519146         12.0    True  00004171de2e758c4842   \n",
       "18           JDBC  1588570519148          9.0    True  00004171de2e758c4842   \n",
       "45          LOCAL  1588570519159          3.0    True  00004171de2e758c4842   \n",
       "19           JDBC  1588570519160          1.0    True  00004171de2e758c4842   \n",
       "46          LOCAL  1588570519162          4.0    True  00004171de2e758c4842   \n",
       "20           JDBC  1588570519165          0.0    True  00004171de2e758c4842   \n",
       "47          LOCAL  1588570519166          3.0    True  00004171de2e758c4842   \n",
       "21           JDBC  1588570519168          0.0    True  00004171de2e758c4842   \n",
       "48          LOCAL  1588570519170          3.0    True  00004171de2e758c4842   \n",
       "22           JDBC  1588570519172          0.0    True  00004171de2e758c4842   \n",
       "49          LOCAL  1588570519173          5.0    True  00004171de2e758c4842   \n",
       "23           JDBC  1588570519177          1.0    True  00004171de2e758c4842   \n",
       "50          LOCAL  1588570519179         82.0    True  00004171de2e758c4842   \n",
       "24           JDBC  1588570519179          2.0    True  00004171de2e758c4842   \n",
       "25           JDBC  1588570519257          3.0    True  00004171de2e758c4842   \n",
       "\n",
       "                      id                   pid     cmdb_id  dsName  \\\n",
       "56  3b2a9171de2e758c4843                  None      os_021     NaN   \n",
       "26  2d6ca171de2e75914849  3b2a9171de2e758c4843      os_021     NaN   \n",
       "51  6f699171de2e75921822  2d6ca171de2e75914849  docker_004     NaN   \n",
       "57  a41a9171de2e75941824  6f699171de2e75921822  docker_004     NaN   \n",
       "27  2b0d6171de2e759a1828  6f699171de2e75921822  docker_004     NaN   \n",
       "52  ffa48171de2e759e2825  2b0d6171de2e759a1828  docker_006     NaN   \n",
       "31  cbcfc171de2e75b52860  ffa48171de2e759e2825  docker_006  db_003   \n",
       "0   a52e4171de2e75b52863  cbcfc171de2e75b52860  docker_006  db_003   \n",
       "1   fa2fe171de2e75bc2880  cbcfc171de2e75b52860  docker_006  db_003   \n",
       "28  1e068171de2e75c71834  6f699171de2e75921822  docker_004     NaN   \n",
       "53  73c90171de2e75ce2907  1e068171de2e75c71834  docker_006     NaN   \n",
       "2   89bdd171de2e75dc2926  cbc31171de2e75dc2923  docker_006  db_003   \n",
       "32  cbc31171de2e75dc2923  73c90171de2e75ce2907  docker_006  db_003   \n",
       "3   c77f4171de2e75e42943  cbc31171de2e75dc2923  docker_006  db_003   \n",
       "33  cb38e171de2e75ee2953  73c90171de2e75ce2907  docker_006  db_003   \n",
       "4   6d325171de2e75f22970  cb38e171de2e75ee2953  docker_006  db_003   \n",
       "29  ec8b7171de2e76011840  6f699171de2e75921822  docker_004     NaN   \n",
       "54  4d259171de2e76053004  ec8b7171de2e76011840  docker_006     NaN   \n",
       "34  b2de2171de2e76123027  4d259171de2e76053004  docker_006  db_003   \n",
       "5   57b70171de2e76123030  b2de2171de2e76123027  docker_006  db_003   \n",
       "6   bbcbf171de2e761c3053  b2de2171de2e76123027  docker_006  db_003   \n",
       "35  cf1eb171de2e76213063  4d259171de2e76053004  docker_006  db_003   \n",
       "7   6375d171de2e76233069  cf1eb171de2e76213063  docker_006  db_003   \n",
       "30  3c536171de2e763f1846  6f699171de2e75921822  docker_004     NaN   \n",
       "55  336e7171de2e76423087  3c536171de2e763f1846  docker_006     NaN   \n",
       "36  8fd44171de2e76493099  336e7171de2e76423087  docker_006  db_003   \n",
       "8   ae9e2171de2e76493102  8fd44171de2e76493099  docker_006  db_003   \n",
       "9   36fd3171de2e764e3111  8fd44171de2e76493099  docker_006  db_003   \n",
       "10  4cd5f171de2e765b1868  a0d50171de2e765b1863  docker_004  db_009   \n",
       "37  a0d50171de2e765b1863  6f699171de2e75921822  docker_004  db_009   \n",
       "11  e7045171de2e765c1874  a0d50171de2e765b1863  docker_004  db_009   \n",
       "38  65389171de2e765d1876  6f699171de2e75921822  docker_004  db_009   \n",
       "12  48a3e171de2e765e1884  65389171de2e765d1876  docker_004  db_009   \n",
       "39  0d7f4171de2e765f1888  6f699171de2e75921822  docker_004  db_009   \n",
       "13  e6299171de2e76601891  0d7f4171de2e765f1888  docker_004  db_009   \n",
       "14  279be171de2e76611899  52591171de2e76611896  docker_004  db_009   \n",
       "40  52591171de2e76611896  6f699171de2e75921822  docker_004  db_009   \n",
       "41  bdf07171de2e76621903  6f699171de2e75921822  docker_004  db_009   \n",
       "15  6a194171de2e76631909  bdf07171de2e76621903  docker_004  db_009   \n",
       "42  3743e171de2e76641913  6f699171de2e75921822  docker_004  db_009   \n",
       "16  0abff171de2e76651919  3743e171de2e76641913  docker_004  db_009   \n",
       "43  08150171de2e76661923  6f699171de2e75921822  docker_004  db_009   \n",
       "17  466a8171de2e76691934  08150171de2e76661923  docker_004  db_009   \n",
       "44  34d9b171de2e766a1941  6f699171de2e75921822  docker_004  db_009   \n",
       "18  d38af171de2e766c1956  34d9b171de2e766a1941  docker_004  db_009   \n",
       "45  1d347171de2e76771966  6f699171de2e75921822  docker_004  db_009   \n",
       "19  0bdb7171de2e76781973  1d347171de2e76771966  docker_004  db_009   \n",
       "46  4dec7171de2e767a1980  6f699171de2e75921822  docker_004  db_009   \n",
       "20  c1567171de2e767d1989  4dec7171de2e767a1980  docker_004  db_009   \n",
       "47  35818171de2e767e1998  6f699171de2e75921822  docker_004  db_009   \n",
       "21  517b0171de2e76802008  35818171de2e767e1998  docker_004  db_009   \n",
       "48  50cbd171de2e76812013  6f699171de2e75921822  docker_004  db_009   \n",
       "22  bc5dd171de2e76842024  50cbd171de2e76812013  docker_004  db_009   \n",
       "49  1298b171de2e76852028  6f699171de2e75921822  docker_004  db_009   \n",
       "23  1e128171de2e76892041  1298b171de2e76852028  docker_004  db_009   \n",
       "50  571d7171de2e768b2048  6f699171de2e75921822  docker_004  db_007   \n",
       "24  33267171de2e768b2051  571d7171de2e768b2048  docker_004  db_007   \n",
       "25  a2c9a171de2e76d92064  571d7171de2e768b2048  docker_004  db_007   \n",
       "\n",
       "         serviceName  \n",
       "56           osb_001  \n",
       "26           csf_001  \n",
       "51           csf_001  \n",
       "57    fly_remote_001  \n",
       "27           csf_002  \n",
       "52           csf_002  \n",
       "31  local_method_011  \n",
       "0                NaN  \n",
       "1                NaN  \n",
       "28           csf_003  \n",
       "53           csf_003  \n",
       "2                NaN  \n",
       "32  local_method_013  \n",
       "3                NaN  \n",
       "33  local_method_014  \n",
       "4                NaN  \n",
       "29           csf_004  \n",
       "54           csf_004  \n",
       "34  local_method_015  \n",
       "5                NaN  \n",
       "6                NaN  \n",
       "35  local_method_016  \n",
       "7                NaN  \n",
       "30           csf_005  \n",
       "55           csf_005  \n",
       "36  local_method_017  \n",
       "8                NaN  \n",
       "9                NaN  \n",
       "10               NaN  \n",
       "37  local_method_001  \n",
       "11               NaN  \n",
       "38  local_method_002  \n",
       "12               NaN  \n",
       "39  local_method_002  \n",
       "13               NaN  \n",
       "14               NaN  \n",
       "40  local_method_003  \n",
       "41  local_method_004  \n",
       "15               NaN  \n",
       "42  local_method_004  \n",
       "16               NaN  \n",
       "43  local_method_004  \n",
       "17               NaN  \n",
       "44  local_method_004  \n",
       "18               NaN  \n",
       "45  local_method_005  \n",
       "19               NaN  \n",
       "46  local_method_006  \n",
       "20               NaN  \n",
       "47  local_method_007  \n",
       "21               NaN  \n",
       "48  local_method_006  \n",
       "22               NaN  \n",
       "49  local_method_009  \n",
       "23               NaN  \n",
       "50  local_method_010  \n",
       "24               NaN  \n",
       "25               NaN  "
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_single_trace.sort_values('startTime')\n",
    "for i in range(df_single_trace.shape[0]):\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_tl = pd.read_csv('../data/train_data/trace_list.csv', header=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>db_003</td>\n",
       "      <td>(('Start', 'osb_001'), ('osb_001', 'docker_002...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>db_003</td>\n",
       "      <td>(('Start', 'osb_001'), ('osb_001', 'docker_001...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>csf_005</td>\n",
       "      <td>(('Start', 'osb_001'), ('osb_001', 'docker_001...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>docker_008</td>\n",
       "      <td>(('Start', 'osb_001'), ('osb_001', 'docker_002...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>db_007</td>\n",
       "      <td>(('Start', 'osb_001'), ('osb_001', 'docker_002...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            0                                                  1\n",
       "0      db_003  (('Start', 'osb_001'), ('osb_001', 'docker_002...\n",
       "1      db_003  (('Start', 'osb_001'), ('osb_001', 'docker_001...\n",
       "2     csf_005  (('Start', 'osb_001'), ('osb_001', 'docker_001...\n",
       "3  docker_008  (('Start', 'osb_001'), ('osb_001', 'docker_002...\n",
       "4      db_007  (('Start', 'osb_001'), ('osb_001', 'docker_002..."
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_tl.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
